SaBillCode 
Logical Entity Name  SaBillCode 
Default Table Name  SaBillCode 
Physical Only  NO 
Definition 
 
Note 
 

SaBillCode Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(8)  NO 
 
Descrip    varchar(35)  NO 
 
SyCampusGrpID    int  NO 
 
BillType    char(1)  NO 
 
MiscCashGLNo    varchar(20)  NO 
 
EditMiscCashGLNo    bit  NO 
 
DeferEarnings    bit  NO 
 
Active    bit  NO 
 
SystemCode    bit  NO 
 
ModFlag    char(1)  NO 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
SaBillCodeID(PK)    int  NO 
 
TitleIVCharge    bit  NO 
 
ReqTermOverride    bit  NO 
 
RevenuePeriod    char(1)  YES 
 
SA1098T    bit  NO 
 
Deposits    bit  NO 
 
SchoolActRevenue    bit  YES 
 
TitleIVCharge_nowaiver    bit  NO 
 
Interest    bit  NO 
 
IncludeInRevenueRec    bit  NO 
 
AmortizeNegativeRevenue    bit  YES 
 
RetakeFee    bit  NO 
 
SaBillCodeCategoryId(FK)    int  YES 
 
blnBillOncePerStudent    bit  YES 
 

SaBillCode Primary and Unique Keys 
Key Name  Key Type  Keys 
SaBillCode_Code_U_N_IDX  Index  Code 
SaBillCode_SaBillCodeID_U_C_IDX  PrimaryKey  SaBillCodeID 

SaBillCode Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SaBillCodeCategory  Non-Identifying  Zero or One to Zero or More  FK_SaBillCodeSaBillCodeCategoryId_SaBillCodeCategorySaBillCodeCategoryId      SaBillCodeCategoryId  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AmDeposit  Non-Identifying  One To Zero or More  Fk_AmDeposits_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HsApplication  Non-Identifying  One To Zero or More  FK_HsApplication_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HsBuildingRooms  Non-Identifying  One To Zero or More  FK_HsBuildingRooms_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HsBuildingSuites  Non-Identifying  One To Zero or More  FK_HsBuildingSuites_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HSStudentLeaseChargeSchedule  Non-Identifying  One To Zero or More  FK_HSStudentLeaseChargeSchedule_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HsStudentLeaseHistorySaTransCodeID_SaBillCodeSaBillCodeID        NO  YES 
SaAutoBillBatchDetail  Non-Identifying  One To Zero or More  FK_SaAutoBillBatchDetail_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaAutoCharge  Non-Identifying  One To Zero or More  FK_SaAutoCharge_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SAAutoChargeProgramVersion  Non-Identifying  One To Zero or More  FK_SAAutoChargeProgramVersion_SABillCodeId_SABillCode_SABillCodeId        NO  YES 
SaBillCodeRevenuePeriod  Non-Identifying  One To Zero or More  FK_SaBillCodeRevenuePeriod_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaBillCodeStaffGroupPost  Non-Identifying  One To Zero or More  FK_SaBillCodeStaffGroupPost_SaBillCodeID_SaBillCode_SaBillCodeId        NO  YES 
SaCourseRefundPolicyBillCode  Non-Identifying  One To Zero or More  FK_SaCourseRefundPolicyBillCode_SaBillCodeId_SaBillCode_SaBillCodeID        NO  YES 
SaCreditSourceApplyOrder  Non-Identifying  One To Zero or More  Fk_SaCreditSourceApplyOrder_SaBillCodeId        NO  NO 
SaPaymentApplyOrder  Non-Identifying  One To Zero or More  FK_SaPaymentApplyOrder_SaBillCodeId_SaBillCode_SaBillCodeId        NO  YES 
SaPendingCharge  Non-Identifying  One To Zero or More  FK_saPendingCharge.SaBillCodeID_SaBillCode.SaBillCodeID        NO  YES 
SaPendingChargeCourseAmount  Non-Identifying  One To Zero or More  FK_SaPendingChargeCourseAmount_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaRefundBillCodes  Non-Identifying  One To Zero or More  FK_SaRefundBillCodes_MappedBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaRefundCalcAdjust  Non-Identifying  One To Zero or More  FK_SaRefundCalcAdjust_MainBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaStudSubsidiaryTrans  Non-Identifying  One To Zero or More  Fk_SaStudSubsidiaryTrans_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaSubsidiary  Non-Identifying  One To Zero or More  FK_SaSubsidiary_DefSaBillCodeId_SaBillCode_SaBillCodeId        NO  YES 
SaSubsidiaryBillCodes  Non-Identifying  One To Zero or More  Fk_SaSubsidiaryBillCodes_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaTransCourseAmount  Non-Identifying  One To Zero or More  FK_SaTransCourseAmount_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SaTuitionDiscountPolicy  Non-Identifying  One To Zero or More  FK_SaTuitionDiscountPolicy_SaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 
SyPaymentAccount  Non-Identifying  One To Zero or More  FK_SyPaymentAccount_TransFeeSaBillCodeID_SaBillCode_SaBillCodeID        NO  YES 

SaBillCode Check Constraints 
Check Constraint Name  CheckConstraint